package com.handtransaction.dao;

import com.handtransaction.entity.OSGoods;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * 对下架商品表进行操作
 */
@Repository
public interface OffShelfGoodsDao {
    //增加 -- 商品被下架
    @Insert("insert into offshelfgoods (osadminid,osadminname,osgid,osgname,osgsrc,osguid,osreason) values " +
    "(#{osadminid},#{osadminname},#{osgid},#{osgname},#{osgsrc},#{osguid},#{osreason})")
    int insertOSGoods(OSGoods osGoods);

    //查看所有已被下架的商品
    @Select("select * from offshelfgoods ")
    List<OSGoods> queryAllOSGoods();


}
